Towards Dynamic Green-Sizing for Database Servers
نویسندگان
چکیده
This paper presents two techniques for reducing the power consumed by database servers. Both techniques are intended primarily for transactional workloads on servers with memory-resident databases. The first technique is databasemanaged dynamic processor voltage and frequency scaling (DVFS). We show that a DBMS can exploit its knowledge of the workload and performance constraints to obtain power savings that are more than twice as large as the power savings achieved when DVFS is managed by the operating system. The second technique is rank-aware memory allocation, the goal of which is to power memory that the database system needs and avoid powering memory it does not need. We present experiments that show rank-aware allocation allows unneeded memory to move to low-power states, reducing memory power consumption.
منابع مشابه
Sizing Considerations for Enterprise Applications in Dynamic Data Centre Environments
Dynamic data centres are regarded as promising approach to achieve a high degree of resource utilization. In such data centres, applications are dynamically allocated to servers under consideration of the actual resource demand and the actual load states of the servers. However, as a result of this flexible deployment model, it is difficult to size the initial servers and other hardware equipme...
متن کاملSeparating indexes from data: a distributed scheme for secure database outsourcing
Database outsourcing is an idea to eliminate the burden of database management from organizations. Since data is a critical asset of organizations, preserving its privacy from outside adversary and untrusted server should be warranted. In this paper, we present a distributed scheme based on storing shares of data on different servers and separating indexes from data on a distinct server. Shamir...
متن کاملWe are all Economists Now
Multiple virtual machine (VM) workloads are increasingly common, given the growth of managed enterprise application systems and consolidated virtual servers. Until now, there has been no principled approach to partitioning memory resource between multiple co-located VMs. In this paper, we develop a general framework for multi-VM heap sizing, based on the principle of utility maximization from m...
متن کاملPerformance Measurement of the PeopleSoft Multi-Tier Remote Computing Application
Center for Information Technology Integration University of Michigan 519 West William Street Ann Arbor, MI 48103-4943 CITI Technical Report 98–3 Performance Measurement of the PeopleSoft Multi-Tier Remote Computing Application Yi-Chun Chu [email protected] Charles J. Antonelli [email protected] Toby J. Teorey [email protected] The Center for Information Technology Integration has undert...
متن کاملLoad Balancing Approaches for Web Servers: A Survey of Recent Trends
Numerous works has been done for load balancing of web servers in grid environment. Reason behinds popularity of grid environment is to allow accessing distributed resources which are located at remote locations. For effective utilization, load must be balanced among all resources. Importance of load balancing is discussed by distinguishing the system between without load balancing and with loa...
متن کامل